I am working at multi-language web site. I need to save Unicode data on my
MS SQL 2000 Data Base. I would like to save data on utf-8 format but on this
case I have a problem with sorting non English records and transferring them
to UPPER case.
Could you suggest any ideas or methods to solve this problem.
SQL Server Developer >> Working with unicode
Alexei
Have you tried to define NVARCHAR(n)/NCHAR(n) on those columns?
> Hello.
>
> I am working at multi-language web site. I need to save Unicode data on my
> MS SQL 2000 Data Base. I would like to save data on utf-8 format but on
this
> case I have a problem with sorting non English records and transferring
them
> to UPPER case.
>
> Could you suggest any ideas or methods to solve this problem.
>
>
>
> Best regards.
>
> Aleksei
>
>
SQL Server Developer >> Working with unicode
Hello Uri. Thank you for your reply.
Yes of course I use nvarchar collumn because you can not write unicode data
to varchar column.
I think the problem is internal of MSSQL and haw it works with unicode.
If you try execute SQL command
SELECT myfield, UPPER(myfield) AS Upper_myfield FROM mytable
SQL Server Developer >> Working with unicode
Can you provide your SELECT statement with UNICODE data?
> Hello Uri. Thank you for your reply.
> Yes of course I use nvarchar collumn because you can not write unicode
data
> to varchar column.
> I think the problem is internal of MSSQL and haw it works with unicode.
> If you try execute SQL command
> SELECT myfield, UPPER(myfield) AS Upper_myfield FROM mytable
>
> You will see that MSSQL give you incorrect data
>
> Best Regards
> Aleksei
>
>