|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Code page translation
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Code page translation
|
|
| Michael Tissington 2002-11-09, 12:23 pm |
| I'm getting a code page translation error for a text field From 1255 to
1252.
How do I change the database so this does not happen. I assume I have to do
something with the collation for the table but not sure.
Thanks.
--
Michael Tissington
Oaklodge Technologies
http://www.oaklodge.com/technology
| |
| Erland Sommarskog 2002-11-10, 6:23 pm |
| Michael Tissington (michael@nospam.com) writes:
> I'm getting a code page translation error for a text field From 1255 to
> 1252.
>
> How do I change the database so this does not happen. I assume I have to
> do something with the collation for the table but not sure.
Could you describe your problem more in detail? When do you get this
error? What collation does the table column have? And what codepage
is 1255? (1252 is Western Latin-1, that I know.)
To change the collation of a column, this statement appears to work:
alter table NEW_H alter column H_Name nvarchar(50)
COLLATE Lithuanian_CS_AS
--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se
I support PASS - the definitive global community for SQL Server
professionals - http://www.sqlpass.org
The PASS Community Summit is in Seattle Nov 19-22, I'll be there. And you?
| |
| Michael Tissington 2002-11-11, 3:23 pm |
| I think 1255 Is Hebrew ....
--
Michael Tissington
Oaklodge Technologies
http://www.oaklodge.com/technology
"Erland Sommarskog" <sommar@algonet.se> wrote in message
news:Xns92C3C0646B60Yazorman@1
27.0.0.1...
> Michael Tissington (michael@nospam.com) writes:
> > I'm getting a code page translation error for a text field From 1255 to
> > 1252.
> >
> > How do I change the database so this does not happen. I assume I have to
> > do something with the collation for the table but not sure.
>
> Could you describe your problem more in detail? When do you get this
> error? What collation does the table column have? And what codepage
> is 1255? (1252 is Western Latin-1, that I know.)
>
> To change the collation of a column, this statement appears to work:
>
> alter table NEW_H alter column H_Name nvarchar(50)
> COLLATE Lithuanian_CS_AS
>
>
> --
> Erland Sommarskog, SQL Server MVP, sommar@algonet.se
> I support PASS - the definitive global community for SQL Server
> professionals - http://www.sqlpass.org
> The PASS Community Summit is in Seattle Nov 19-22, I'll be there. And you?
| |
| Erland Sommarskog 2002-11-11, 6:23 pm |
| Michael Tissington (michael@nospam.com) writes:
> I think 1255 Is Hebrew ....
OK. Then you should probably use a Hebrew collation, rather than a
Lithuanian as I used in the example.
--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se
I support PASS - the definitive global community for SQL Server
professionals - http://www.sqlpass.org
The PASS Community Summit is in Seattle Nov 19-22, I'll be there. And you?
|
|
|
|
|