MS SQL Server - Storing Polish characters in SQL Server

Author

Storing Polish characters in SQL Server

Peter Lo

2006-03-05, 8:23 pm

Hi! Our system is running on a SQL Server using collation
'SQL_Latin1_General_
CP1_CS_AS'. Now, we have a client who has an office in
Poland. This client want to install our software there. They want to be able
to enter Polish characters. So, what should I do to our SQL Server database
so that it can store Polish characters. Does client need to install a SQL
Server using collation for Polish. If client has used Polish collation for
their database, can this database still store english characters? OR, can
client uses UNICODE for their databases? If this is the case, I then need to
change all my db scripts to use the data type like NVARCHAR, etc.

-- Peter Lo

David Barber [MS]

2006-03-05, 8:24 pm

Storing multilingual character data in one of the Unicode data types will
prevent loss of data, regardless of the server collation.

For more information, see
http://msdn.microsoft.com/library/d...ataEncoding.asp

--
David Barber [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights

"Peter Lo" <PeterLo@discussions.microsoft.com> wrote in message
news:92799D03-6527-4952-AE40- 09F50BDA6A9B@microso
ft.com...
> Hi! Our system is running on a SQL Server using collation
> 'SQL_Latin1_General_
CP1_CS_AS'. Now, we have a client who has an office in
> Poland. This client want to install our software there. They want to be
able
> to enter Polish characters. So, what should I do to our SQL Server
database
> so that it can store Polish characters. Does client need to install a SQL
> Server using collation for Polish. If client has used Polish collation for
> their database, can this database still store english characters? OR, can
> client uses UNICODE for their databases? If this is the case, I then need
to
> change all my db scripts to use the data type like NVARCHAR, etc.
>
> -- Peter Lo

Sponsored Links