July 10, 2006 at 12:45 pm
I am using SQL Server 2000 and have a hungarian character which looks like a lower case o with two single quotes on top of it --> o
I have this character stored in two table the datatype of the column where this is stored at is varchar in one table and nvarchar in the other. When I try to view the field in enterprise manager the character appears as it should in the 2 tables, but when I use a jsp page deployed on weblogic to look at this character the one stored in the column of type varchar displays perfectly, but the table in which the column is nvarchar the character on the jsp page appears as a Q instead.
Any inputs on how to correct this issue will be much appreciated. Any changes to the character set on the html / jsp pages has no affect on the result.
Thanks,
Manisha
July 11, 2006 at 1:36 am
Hi..
Without a full repro, it's difficult to draw a firm conclusion about your issue. At first blush, though, it sounds as though it might be a collation issue in the database query.
Hope this helps!
- Ward Pond
blogs.technet.com/wardpond
July 11, 2006 at 3:31 pm
The column uses the default database collation which is set to SQL_Latin1_General_CP1_CI_AS
The specific column in the table has data for more than one language. The problem arises when the we use hungarian language which is not a part of Latin1 charset.
Can a column have more than one collation as hungarian is a eastern european language and is not a part of the Latin 1 collation sequence or do I have to have a separate column for the eastern european languages?
Any inputs will be appreciated.
Thanks,
Manisha
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply