Mssql

Non standard characters....

[giggle]

Hi

Not sure how to phrase this problem, but:

When my colleagues maintain data that contains certain currency symbols or the degree circle symbol in our Visual Basic system and then I try and load the information up onto our MS SQL database the system generates an error and the data containing the (non-standard characters?) cannot be saved.

Any idea how I can encode this information?

Thanks

Mick

[kona]

If you want to store special characters it would be best for the relevant columns in your database to be one of the Unicode data types (nchar, nvarchar, ntext).

[giggle]

Sorry for taking so long in replying.

Thanks Kona, nchar worked a treat.

Mick