Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 how to set the SQL 2000 DB to accept diff language

Author  Topic 

bjigar
Starting Member

3 Posts

Posted - 2007-07-30 : 16:34:33
We have a need on the database for it to be able to accept French language. Currently when I try and submit a record to the database in French it translates some of the characters to some other funky code. Do you know of anything in the SQL database that can be tweaked for it to allow French language?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-07-30 : 17:08:19
Does French use uni-code characters? If so, are you using uni-code data types (nchar, nvarchar, ntext)?

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

bjigar
Starting Member

3 Posts

Posted - 2007-07-31 : 10:14:42
Tara i am not sure whether it uses uni-code character or not is there a way to check and confirm it
thanks
Go to Top of Page

Sini
Starting Member

18 Posts

Posted - 2007-07-31 : 11:05:23
Unicode characters are accented characters such as é ó á etc.

French clearly uses them so i would try using unicode data-types to fix the issue.
Go to Top of Page
   

- Advertisement -