Greek characters saved in SQL Server 2000

Forum Moderators: open

Message Too Old, No Replies

Greek characters saved in SQL Server 2000

007~ASP 0104~Operation not Allowed~

dataguy

7:44 pm on Dec 10, 2006 (gmt 0)

I have a website which accepts user-created content and whenever someone submits something with non-American English characters, an error is thrown which states " 007~ASP 0104~Operation not Allowed~".

This site runs classic ASP and SQL Server 2000. I've had several developers look at the issue but none of been able to help.

Any idea's what is going on and what I can do about it?

stajer

8:35 pm on Dec 10, 2006 (gmt 0)

I am not entirely familiar with this, but I believe you have to set the language encoding for your tables in mssql. So, a table set to Western European will be unable to save greek, cyrillic, hebrew, etc characters. You will have to store that type of data in a different table or convert it to ascii codes.

iamlost

8:53 pm on Dec 10, 2006 (gmt 0)

I am not sure but could you use the COLLATE clause to specify any differing (from default) collations for user generated literal strings?

[msdn2.microsoft.com ]

When you specify a literal string, you can use the COLLATE clause to specify the collation. If you do not specify a collation, the literal is assigned the database default collation.