|
|
| P Platan 2006-02-28, 8:23 pm |
| Hi!
I am having a problem concerning collations.
I have an SQL Server 2000 with Latin1_General_CI_AS
which contains the company data.Some of the fields are Greek and although I
cannot view them correctly in the Query Analyzer , the tool we are using
(powerbuilder) displays them OK.
now that w e want to go Internet we are facing problems with the Greek
fields not displayes correctly...
What can we do in order to have them displayed correctly?
Thanx in advance!
| |
| Uri Dimant 2006-02-28, 8:23 pm |
| Hi
Do you define the column which displays the database as NAVARCHAR(n)?
"P Platan" <pplat@exnds.com> wrote in message
news:Ohzqo8FPGHA.2704@TK2MSFTNGP15.phx.gbl...
> Hi!
>
> I am having a problem concerning collations.
> I have an SQL Server 2000 with Latin1_General_CI_AS
> which contains the company data.Some of the fields are Greek and although
> I cannot view them correctly in the Query Analyzer , the tool we are using
> (powerbuilder) displays them OK.
>
> now that w e want to go Internet we are facing problems with the Greek
> fields not displayes correctly...
> What can we do in order to have them displayed correctly?
>
> Thanx in advance!
>
| |
| P Platan 2006-02-28, 8:23 pm |
| unfortunately no!
it is an old database.migrated from ASA...
"Uri Dimant" <urid@iscar.co.il> wrote in message
news:e4ea9AGPGHA.1288@TK2MSFTNGP09.phx.gbl...
> Hi
> Do you define the column which displays the database as NAVARCHAR(n)?
>
>
>
> "P Platan" <pplat@exnds.com> wrote in message
> news:Ohzqo8FPGHA.2704@TK2MSFTNGP15.phx.gbl...
>
>
| |
| Uri Dimant 2006-02-28, 8:23 pm |
| Well. please read article aboit UNICODE in the BOL
If so, you are going to alter the table and change the datatype
"P Platan" <pplat@exnds.com> wrote in message
news:%23ttL1FGPGHA.2828@TK2MSFTNGP12.phx.gbl...
> unfortunately no!
> it is an old database.migrated from ASA...
>
>
>
> "Uri Dimant" <urid@iscar.co.il> wrote in message
> news:e4ea9AGPGHA.1288@TK2MSFTNGP09.phx.gbl...
>
>
| |
| P Platan 2006-02-28, 8:23 pm |
| thanx!!
...what is BOL?
and if I alter the table will I be able to have the already stored Greek
fields displayed correctly?
"Uri Dimant" <urid@iscar.co.il> wrote in message
news:%23h1JdIGPGHA.1180@TK2MSFTNGP09.phx.gbl...
> Well. please read article aboit UNICODE in the BOL
>
> If so, you are going to alter the table and change the datatype
>
>
>
> "P Platan" <pplat@exnds.com> wrote in message
> news:%23ttL1FGPGHA.2828@TK2MSFTNGP12.phx.gbl...
>
>
| |
| Uri Dimant 2006-02-28, 8:23 pm |
| > ..what is BOL?
Books On Line
> and if I alter the table will I be able to have the already stored Greek
> fields displayed correctly?
Yes, read the article in the BOL
"P Platan" <pplat@exnds.com> wrote in message
news:OWcXWKGPGHA.2300@TK2MSFTNGP15.phx.gbl...
> thanx!!
>
> ..what is BOL?
>
> and if I alter the table will I be able to have the already stored Greek
> fields displayed correctly?
>
> "Uri Dimant" <urid@iscar.co.il> wrote in message
> news:%23h1JdIGPGHA.1180@TK2MSFTNGP09.phx.gbl...
>
>
|
|
|
|