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)
 Multi Language Character Support

Author  Topic 

rhankin
Starting Member

5 Posts

Posted - 2007-03-12 : 07:21:57
I have a SQL 2000 Server set up with Latin1_General_BIN collation. I need to allow polish characters on this server but am unaware of how to allow it.

I have created a new DB using Polish_BIN collation but the only way i can enter polish characters is using nchar for unicode support.
Our ERP system uses non-unicode char fields for it's text data.

I have even tried installing polish language support in windows, changing my sql login to polish language and even used "Set Language Polish" to change my server default language and it still only works in unicode

If anyone is able to tell me how I can enable this polish support on my server I would be very grateful

Thanks

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2007-03-12 : 10:25:29
If your fields are NOT unicode friendly, you're going to loose on this requirement.
Non-unicode fields really only support English character sets. I'd bet that your ERP database will have to be amended to use nchar/ nvarchar/ ntext fields.
Go to Top of Page
   

- Advertisement -