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 change the default ISO-8859-1 codepage???

Author  Topic  perini14 Starting Member 1 Post Posted - 2001-08-17 : 10:35:15 I want to use Central European, 1250 codepage, and sortorder for Croatia... I've tryed to use in my tables nchar and nvarchar fields type for croatian unicode, and that worked fine in sql enterprise manager, but, when I tryed to insert new records from visual basic with simple sql insert statement, croatian special charactes have become regular english characters. I've changed the default language with sp_configure, but the result is the same. Maybe I need to change code page to 1250, but I dont know how. I've tryed to rebuild database with new language and unicode settings, but I get an error. Help!!! Edited by - perini14 on 08/17/2001 11:55:51