June 26, 2008 at 5:15 pm
I have some Collation problem I need a help, please!
I have two SAME test databases,
but one (A) has a Collation set to Hebrew_CI_AS, and another one (B) - SQL_Latin1_General_CPT1_CS_AS.
Both databases have a Synopsis table with a column NVARCHAR(1000), holding programmes EPG.
In database (A) the COLUMN's Collation is set to SQL_Latin1_.... ( an opposit to the database ! )
In database (B) the COLUMN's Collation is set to Hebrew_CI_... (again - an opposit to the database)
My problem is:
When I want to update this column on databse (A) with special latin tags, f.e. ñç, I get question marks only: UPDATE A..Synopsis SET ... = 'Pour Bébé' shows me Pour B?b?
On the other hand, if in database (B) I want to type some Hebrew carachters, I get ???????? as well.
It seems that despite I have a specified collation on my column, SQL keeps ignore it.
How can I fix it?
Many thanks in advance
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply