Hong kong fonts

I am using sql server 2000 english
Once i insert chinese font, it is ok
But when I insert one hong kong font, then it make whole chinese font
crack...
But when i copy whole message and update(not insert), then the text can be
shown
is it microsoft bug?Izumi,
It is difficult to know, because you have not provided much information.
If you are inserting Simplified Chinese characters in GB encoding and
Traditional (Hong Kong) characters in Big-5 encoding, perhaps you have
code page support only for GB and not Big-5.
If you can use Unicode in all cases, it should be possible to handle
both character sets.
Please tell us the data type of the column (probably varchar, nvarchar,
text, or ntext) how you are inserting data. INSERT query, or data file
import, or typing in Enterprise Manager or some tool? Also, how do you
do the update? If you specify character strings in a query, do you use
N'ÄãµÄºº×Ö' or 'ÄãµÄºº×Ö' (is there N or not for Unicode)?
It could also be a bug, and the additional information will help.
SK
izumi wrote:
>I am using sql server 2000 english
>Once i insert chinese font, it is ok
>But when I insert one hong kong font, then it make whole chinese font
>crack...
>But when i copy whole message and update(not insert), then the text can be
>shown
>is it microsoft bug?
>
>|||Good, I find the good person to solve the problem
u really understand my story
ok
let me explain
ASP page to insert and update the character to sql server
It is not GB
It is Big5 actually
but there are around 5000 Hong Kong words which is not Big5
so we need some additional hong kong character set to recongize some hong
kong words
http://www.microsoft.com/hk/hkscs/default.asp
you can see the details
The word I cannot insert is one out of 5000
sure I use N'...in asp page
And i use nvarchar for data type
it is unicode
that what I said it was running well before
but for special hong kong character
when insert, the words is crack
when update hong kong character, it is running well, no crack
"Steve Kass" <skass@.drew.edu> wrote in message
news:uFMQzcP0DHA.604@.tk2msftngp13.phx.gbl...
> Izumi,
> It is difficult to know, because you have not provided much information.
> If you are inserting Simplified Chinese characters in GB encoding and
> Traditional (Hong Kong) characters in Big-5 encoding, perhaps you have
> code page support only for GB and not Big-5.
> If you can use Unicode in all cases, it should be possible to handle
> both character sets.
> Please tell us the data type of the column (probably varchar, nvarchar,
> text, or ntext) how you are inserting data. INSERT query, or data file
> import, or typing in Enterprise Manager or some tool? Also, how do you
> do the update? If you specify character strings in a query, do you use
> N'ÄãµÄºº×Ö' or 'ÄãµÄºº×Ö' (is there N or not for Unicode)?
> It could also be a bug, and the additional information will help.
> SK
> izumi wrote:
> >I am using sql server 2000 english
> >
> >Once i insert chinese font, it is ok
> >
> >But when I insert one hong kong font, then it make whole chinese font
> >crack...
> >
> >But when i copy whole message and update(not insert), then the text can
be
> >shown
> >
> >is it microsoft bug?
> >
> >
> >
> >
>|||Izumi,
Do you update from the asp page also? If insert and update are both
from asp page, but insert does not work, I'm not sure what the problem is.
What codepage does your asp page expect for input? Supplementary Hong
Kong character set is a new code page, 951.
SK
izumi wrote:
>Good, I find the good person to solve the problem
>u really understand my story
>ok
>let me explain
>ASP page to insert and update the character to sql server
>It is not GB
>It is Big5 actually
>but there are around 5000 Hong Kong words which is not Big5
>so we need some additional hong kong character set to recongize some hong
>kong words
>http://www.microsoft.com/hk/hkscs/default.asp
>you can see the details
>The word I cannot insert is one out of 5000
>sure I use N'...in asp page
>And i use nvarchar for data type
>it is unicode
>that what I said it was running well before
>but for special hong kong character
>when insert, the words is crack
>when update hong kong character, it is running well, no crack
>
>"Steve Kass" <skass@.drew.edu> wrote in message
>news:uFMQzcP0DHA.604@.tk2msftngp13.phx.gbl...
>
>>Izumi,
>>It is difficult to know, because you have not provided much information.
>>If you are inserting Simplified Chinese characters in GB encoding and
>>Traditional (Hong Kong) characters in Big-5 encoding, perhaps you have
>>code page support only for GB and not Big-5.
>>If you can use Unicode in all cases, it should be possible to handle
>>both character sets.
>>Please tell us the data type of the column (probably varchar, nvarchar,
>>text, or ntext) how you are inserting data. INSERT query, or data file
>>import, or typing in Enterprise Manager or some tool? Also, how do you
>>do the update? If you specify character strings in a query, do you use
>>N'ÄãµÄºº×Ö' or 'ÄãµÄºº×Ö' (is there N or not for Unicode)?
>>It could also be a bug, and the additional information will help.
>>SK
>>izumi wrote:
>>
>>I am using sql server 2000 english
>>Once i insert chinese font, it is ok
>>But when I insert one hong kong font, then it make whole chinese font
>>crack...
>>But when i copy whole message and update(not insert), then the text can
>>
>be
>
>>shown
>>is it microsoft bug?
>>
>>
>>
>
>|||good point
i am using 950
let me try 951
sure both method is doing on Asp
"Steve Kass" <skass@.drew.edu> wrote in message
news:%23n5KoLQ0DHA.3116@.TK2MSFTNGP11.phx.gbl...
> Izumi,
> Do you update from the asp page also? If insert and update are both
> from asp page, but insert does not work, I'm not sure what the problem
is.
> What codepage does your asp page expect for input? Supplementary Hong
> Kong character set is a new code page, 951.
> SK
>
> izumi wrote:
> >Good, I find the good person to solve the problem
> >u really understand my story
> >
> >ok
> >let me explain
> >ASP page to insert and update the character to sql server
> >It is not GB
> >It is Big5 actually
> >but there are around 5000 Hong Kong words which is not Big5
> >so we need some additional hong kong character set to recongize some hong
> >kong words
> >http://www.microsoft.com/hk/hkscs/default.asp
> >you can see the details
> >The word I cannot insert is one out of 5000
> >sure I use N'...in asp page
> >And i use nvarchar for data type
> >it is unicode
> >that what I said it was running well before
> >but for special hong kong character
> >when insert, the words is crack
> >when update hong kong character, it is running well, no crack
> >
> >
> >"Steve Kass" <skass@.drew.edu> wrote in message
> >news:uFMQzcP0DHA.604@.tk2msftngp13.phx.gbl...
> >
> >
> >>Izumi,
> >>
> >>It is difficult to know, because you have not provided much information.
> >>If you are inserting Simplified Chinese characters in GB encoding and
> >>Traditional (Hong Kong) characters in Big-5 encoding, perhaps you have
> >>code page support only for GB and not Big-5.
> >>
> >>If you can use Unicode in all cases, it should be possible to handle
> >>both character sets.
> >>
> >>Please tell us the data type of the column (probably varchar, nvarchar,
> >>text, or ntext) how you are inserting data. INSERT query, or data file
> >>import, or typing in Enterprise Manager or some tool? Also, how do you
> >>do the update? If you specify character strings in a query, do you use
> >>N'ÄãµÄºº×Ö' or 'ÄãµÄºº×Ö' (is there N or not for Unicode)?
> >>
> >>It could also be a bug, and the additional information will help.
> >>
> >>SK
> >>
> >>izumi wrote:
> >>
> >>
> >>
> >>I am using sql server 2000 english
> >>
> >>Once i insert chinese font, it is ok
> >>
> >>But when I insert one hong kong font, then it make whole chinese font
> >>crack...
> >>
> >>But when i copy whole message and update(not insert), then the text can
> >>
> >>
> >be
> >
> >
> >>shown
> >>
> >>is it microsoft bug?
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
> >
> >
>|||when i change to <%
Session.CodePage=9511
Response.Charset="big5"
%>
but it show error on asp
rror Type:
SessionID, ASP 0204 (0x80004005)
An invalid CodePage value was specified.
"izumi" <test@.test.com> wrote in message
news:OtkahXQ0DHA.1700@.TK2MSFTNGP12.phx.gbl...
> good point
> i am using 950
> let me try 951
> sure both method is doing on Asp
> "Steve Kass" <skass@.drew.edu> wrote in message
> news:%23n5KoLQ0DHA.3116@.TK2MSFTNGP11.phx.gbl...
> > Izumi,
> >
> > Do you update from the asp page also? If insert and update are both
> > from asp page, but insert does not work, I'm not sure what the problem
> is.
> > What codepage does your asp page expect for input? Supplementary Hong
> > Kong character set is a new code page, 951.
> >
> > SK
> >
> >
> > izumi wrote:
> >
> > >Good, I find the good person to solve the problem
> > >u really understand my story
> > >
> > >ok
> > >let me explain
> > >ASP page to insert and update the character to sql server
> > >It is not GB
> > >It is Big5 actually
> > >but there are around 5000 Hong Kong words which is not Big5
> > >so we need some additional hong kong character set to recongize some
hong
> > >kong words
> > >http://www.microsoft.com/hk/hkscs/default.asp
> > >you can see the details
> > >The word I cannot insert is one out of 5000
> > >sure I use N'...in asp page
> > >And i use nvarchar for data type
> > >it is unicode
> > >that what I said it was running well before
> > >but for special hong kong character
> > >when insert, the words is crack
> > >when update hong kong character, it is running well, no crack
> > >
> > >
> > >"Steve Kass" <skass@.drew.edu> wrote in message
> > >news:uFMQzcP0DHA.604@.tk2msftngp13.phx.gbl...
> > >
> > >
> > >>Izumi,
> > >>
> > >>It is difficult to know, because you have not provided much
information.
> > >>If you are inserting Simplified Chinese characters in GB encoding and
> > >>Traditional (Hong Kong) characters in Big-5 encoding, perhaps you have
> > >>code page support only for GB and not Big-5.
> > >>
> > >>If you can use Unicode in all cases, it should be possible to handle
> > >>both character sets.
> > >>
> > >>Please tell us the data type of the column (probably varchar,
nvarchar,
> > >>text, or ntext) how you are inserting data. INSERT query, or data file
> > >>import, or typing in Enterprise Manager or some tool? Also, how do you
> > >>do the update? If you specify character strings in a query, do you use
> > >>N'ÄãµÄºº×Ö' or 'ÄãµÄºº×Ö' (is there N or not for Unicode)?
> > >>
> > >>It could also be a bug, and the additional information will help.
> > >>
> > >>SK
> > >>
> > >>izumi wrote:
> > >>
> > >>
> > >>
> > >>I am using sql server 2000 english
> > >>
> > >>Once i insert chinese font, it is ok
> > >>
> > >>But when I insert one hong kong font, then it make whole chinese font
> > >>crack...
> > >>
> > >>But when i copy whole message and update(not insert), then the text
can
> > >>
> > >>
> > >be
> > >
> > >
> > >>shown
> > >>
> > >>is it microsoft bug?
> > >>
> > >>
> > >>
> > >>
> > >>
> > >>
> > >
> > >
> > >
> > >
> >
>|||Did you type 951 or 9511? I don't have any other good ideas, but I will
mention this question to Microsoft and see what they say.
SK
izumi wrote:
>when i change to <%
>Session.CodePage=9511
>Response.Charset="big5"
>%>
>but it show error on asp
>rror Type:
>SessionID, ASP 0204 (0x80004005)
>An invalid CodePage value was specified.
>"izumi" <test@.test.com> wrote in message
>news:OtkahXQ0DHA.1700@.TK2MSFTNGP12.phx.gbl...
>
>>good point
>>i am using 950
>>let me try 951
>>sure both method is doing on Asp
>>"Steve Kass" <skass@.drew.edu> wrote in message
>>news:%23n5KoLQ0DHA.3116@.TK2MSFTNGP11.phx.gbl...
>>
>>Izumi,
>>Do you update from the asp page also? If insert and update are both
>>from asp page, but insert does not work, I'm not sure what the problem
>>
>>is.
>>
>>What codepage does your asp page expect for input? Supplementary Hong
>>Kong character set is a new code page, 951.
>>SK
>>
>>izumi wrote:
>>
>>Good, I find the good person to solve the problem
>>u really understand my story
>>ok
>>let me explain
>>ASP page to insert and update the character to sql server
>>It is not GB
>>It is Big5 actually
>>but there are around 5000 Hong Kong words which is not Big5
>>so we need some additional hong kong character set to recongize some
>>
>hong
>
>>kong words
>>http://www.microsoft.com/hk/hkscs/default.asp
>>you can see the details
>>The word I cannot insert is one out of 5000
>>sure I use N'...in asp page
>>And i use nvarchar for data type
>>it is unicode
>>that what I said it was running well before
>>but for special hong kong character
>>when insert, the words is crack
>>when update hong kong character, it is running well, no crack
>>
>>"Steve Kass" <skass@.drew.edu> wrote in message
>>news:uFMQzcP0DHA.604@.tk2msftngp13.phx.gbl...
>>
>>
>>Izumi,
>>It is difficult to know, because you have not provided much
>>
>information.
>
>>If you are inserting Simplified Chinese characters in GB encoding and
>>Traditional (Hong Kong) characters in Big-5 encoding, perhaps you have
>>code page support only for GB and not Big-5.
>>If you can use Unicode in all cases, it should be possible to handle
>>both character sets.
>>Please tell us the data type of the column (probably varchar,
>>
>nvarchar,
>
>>text, or ntext) how you are inserting data. INSERT query, or data file
>>import, or typing in Enterprise Manager or some tool? Also, how do you
>>do the update? If you specify character strings in a query, do you use
>>N'ÄãµÄºº×Ö' or 'ÄãµÄºº×Ö' (is there N or not for Unicode)?
>>It could also be a bug, and the additional information will help.
>>SK
>>izumi wrote:
>>
>>
>>I am using sql server 2000 english
>>Once i insert chinese font, it is ok
>>But when I insert one hong kong font, then it make whole chinese font
>>crack...
>>But when i copy whole message and update(not insert), then the text
>>
>can
>
>>
>>be
>>
>>
>>shown
>>is it microsoft bug?
>>
>>
>>
>>
>>
>>
>>
>
>|||sorry I change to 951
ASP Error
"Steve Kass" <skass@.drew.edu> wrote in message
news:e9fvssR0DHA.832@.TK2MSFTNGP09.phx.gbl...
> Did you type 951 or 9511? I don't have any other good ideas, but I will
> mention this question to Microsoft and see what they say.
> SK
> izumi wrote:
> >when i change to <%
> >Session.CodePage=9511
> >Response.Charset="big5"
> >%>
> >but it show error on asp
> >rror Type:
> >SessionID, ASP 0204 (0x80004005)
> >An invalid CodePage value was specified.
> >"izumi" <test@.test.com> wrote in message
> >news:OtkahXQ0DHA.1700@.TK2MSFTNGP12.phx.gbl...
> >
> >
> >>good point
> >>i am using 950
> >>let me try 951
> >>
> >>sure both method is doing on Asp
> >>
> >>"Steve Kass" <skass@.drew.edu> wrote in message
> >>news:%23n5KoLQ0DHA.3116@.TK2MSFTNGP11.phx.gbl...
> >>
> >>
> >>Izumi,
> >>
> >>Do you update from the asp page also? If insert and update are both
> >>from asp page, but insert does not work, I'm not sure what the problem
> >>
> >>
> >>is.
> >>
> >>
> >>What codepage does your asp page expect for input? Supplementary Hong
> >>Kong character set is a new code page, 951.
> >>
> >>SK
> >>
> >>
> >>izumi wrote:
> >>
> >>
> >>
> >>Good, I find the good person to solve the problem
> >>u really understand my story
> >>
> >>ok
> >>let me explain
> >>ASP page to insert and update the character to sql server
> >>It is not GB
> >>It is Big5 actually
> >>but there are around 5000 Hong Kong words which is not Big5
> >>so we need some additional hong kong character set to recongize some
> >>
> >>
> >hong
> >
> >
> >>kong words
> >>http://www.microsoft.com/hk/hkscs/default.asp
> >>you can see the details
> >>The word I cannot insert is one out of 5000
> >>sure I use N'...in asp page
> >>And i use nvarchar for data type
> >>it is unicode
> >>that what I said it was running well before
> >>but for special hong kong character
> >>when insert, the words is crack
> >>when update hong kong character, it is running well, no crack
> >>
> >>
> >>"Steve Kass" <skass@.drew.edu> wrote in message
> >>news:uFMQzcP0DHA.604@.tk2msftngp13.phx.gbl...
> >>
> >>
> >>
> >>
> >>Izumi,
> >>
> >>It is difficult to know, because you have not provided much
> >>
> >>
> >information.
> >
> >
> >>If you are inserting Simplified Chinese characters in GB encoding and
> >>Traditional (Hong Kong) characters in Big-5 encoding, perhaps you
have
> >>code page support only for GB and not Big-5.
> >>
> >>If you can use Unicode in all cases, it should be possible to handle
> >>both character sets.
> >>
> >>Please tell us the data type of the column (probably varchar,
> >>
> >>
> >nvarchar,
> >
> >
> >>text, or ntext) how you are inserting data. INSERT query, or data
file
> >>import, or typing in Enterprise Manager or some tool? Also, how do
you
> >>do the update? If you specify character strings in a query, do you
use
> >>N'ÄãµÄºº×Ö' or 'ÄãµÄºº×Ö' (is there N or not for Unicode)?
> >>
> >>It could also be a bug, and the additional information will help.
> >>
> >>SK
> >>
> >>izumi wrote:
> >>
> >>
> >>
> >>
> >>
> >>I am using sql server 2000 english
> >>
> >>Once i insert chinese font, it is ok
> >>
> >>But when I insert one hong kong font, then it make whole chinese
font
> >>crack...
> >>
> >>But when i copy whole message and update(not insert), then the text
> >>
> >>
> >can
> >
> >
> >>
> >>
> >>be
> >>
> >>
> >>
> >>
> >>shown
> >>
> >>is it microsoft bug?
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
> >
> >
>|||Ok lets wait
I will call our users to use update function
that mean insert something rubbish, and then update that row of data.
Thanks
"Steve Kass" <skass@.drew.edu> wrote in message
news:e9fvssR0DHA.832@.TK2MSFTNGP09.phx.gbl...
> Did you type 951 or 9511? I don't have any other good ideas, but I will
> mention this question to Microsoft and see what they say.
> SK
> izumi wrote:
> >when i change to <%
> >Session.CodePage=9511
> >Response.Charset="big5"
> >%>
> >but it show error on asp
> >rror Type:
> >SessionID, ASP 0204 (0x80004005)
> >An invalid CodePage value was specified.
> >"izumi" <test@.test.com> wrote in message
> >news:OtkahXQ0DHA.1700@.TK2MSFTNGP12.phx.gbl...
> >
> >
> >>good point
> >>i am using 950
> >>let me try 951
> >>
> >>sure both method is doing on Asp
> >>
> >>"Steve Kass" <skass@.drew.edu> wrote in message
> >>news:%23n5KoLQ0DHA.3116@.TK2MSFTNGP11.phx.gbl...
> >>
> >>
> >>Izumi,
> >>
> >>Do you update from the asp page also? If insert and update are both
> >>from asp page, but insert does not work, I'm not sure what the problem
> >>
> >>
> >>is.
> >>
> >>
> >>What codepage does your asp page expect for input? Supplementary Hong
> >>Kong character set is a new code page, 951.
> >>
> >>SK
> >>
> >>
> >>izumi wrote:
> >>
> >>
> >>
> >>Good, I find the good person to solve the problem
> >>u really understand my story
> >>
> >>ok
> >>let me explain
> >>ASP page to insert and update the character to sql server
> >>It is not GB
> >>It is Big5 actually
> >>but there are around 5000 Hong Kong words which is not Big5
> >>so we need some additional hong kong character set to recongize some
> >>
> >>
> >hong
> >
> >
> >>kong words
> >>http://www.microsoft.com/hk/hkscs/default.asp
> >>you can see the details
> >>The word I cannot insert is one out of 5000
> >>sure I use N'...in asp page
> >>And i use nvarchar for data type
> >>it is unicode
> >>that what I said it was running well before
> >>but for special hong kong character
> >>when insert, the words is crack
> >>when update hong kong character, it is running well, no crack
> >>
> >>
> >>"Steve Kass" <skass@.drew.edu> wrote in message
> >>news:uFMQzcP0DHA.604@.tk2msftngp13.phx.gbl...
> >>
> >>
> >>
> >>
> >>Izumi,
> >>
> >>It is difficult to know, because you have not provided much
> >>
> >>
> >information.
> >
> >
> >>If you are inserting Simplified Chinese characters in GB encoding and
> >>Traditional (Hong Kong) characters in Big-5 encoding, perhaps you
have
> >>code page support only for GB and not Big-5.
> >>
> >>If you can use Unicode in all cases, it should be possible to handle
> >>both character sets.
> >>
> >>Please tell us the data type of the column (probably varchar,
> >>
> >>
> >nvarchar,
> >
> >
> >>text, or ntext) how you are inserting data. INSERT query, or data
file
> >>import, or typing in Enterprise Manager or some tool? Also, how do
you
> >>do the update? If you specify character strings in a query, do you
use
> >>N'ÄãµÄºº×Ö' or 'ÄãµÄºº×Ö' (is there N or not for Unicode)?
> >>
> >>It could also be a bug, and the additional information will help.
> >>
> >>SK
> >>
> >>izumi wrote:
> >>
> >>
> >>
> >>
> >>
> >>I am using sql server 2000 english
> >>
> >>Once i insert chinese font, it is ok
> >>
> >>But when I insert one hong kong font, then it make whole chinese
font
> >>crack...
> >>
> >>But when i copy whole message and update(not insert), then the text
> >>
> >>
> >can
> >
> >
> >>
> >>
> >>be
> >>
> >>
> >>
> >>
> >>shown
> >>
> >>is it microsoft bug?
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
> >
> >
>|||izumi,
If you speak Chinese, you might find some help by posting your
question to the newsgroup microsoft.cn.iis.asp. There is also a
Japanese inetserver.asp group and several English newsgroups under
microsoft.public.dotnet.framework.aspnet.
Steve
izumi wrote:
>Ok lets wait
>I will call our users to use update function
>that mean insert something rubbish, and then update that row of data.
>Thanks
>"Steve Kass" <skass@.drew.edu> wrote in message
>news:e9fvssR0DHA.832@.TK2MSFTNGP09.phx.gbl...
>
>>Did you type 951 or 9511? I don't have any other good ideas, but I will
>>mention this question to Microsoft and see what they say.
>>SK
>>izumi wrote:
>>
>>when i change to <%
>>Session.CodePage=9511
>>Response.Charset="big5"
>>%>
>>but it show error on asp
>>rror Type:
>>SessionID, ASP 0204 (0x80004005)
>>An invalid CodePage value was specified.
>>"izumi" <test@.test.com> wrote in message
>>news:OtkahXQ0DHA.1700@.TK2MSFTNGP12.phx.gbl...
>>
>>
>>good point
>>i am using 950
>>let me try 951
>>sure both method is doing on Asp
>>"Steve Kass" <skass@.drew.edu> wrote in message
>>news:%23n5KoLQ0DHA.3116@.TK2MSFTNGP11.phx.gbl...
>>
>>
>>Izumi,
>>Do you update from the asp page also? If insert and update are both
>>
>>from asp page, but insert does not work, I'm not sure what the problem
>>
>>
>>is.
>>
>>
>>What codepage does your asp page expect for input? Supplementary Hong
>>Kong character set is a new code page, 951.
>>SK
>>
>>izumi wrote:
>>
>>
>>Good, I find the good person to solve the problem
>>u really understand my story
>>ok
>>let me explain
>>ASP page to insert and update the character to sql server
>>It is not GB
>>It is Big5 actually
>>but there are around 5000 Hong Kong words which is not Big5
>>so we need some additional hong kong character set to recongize some
>>
>>
>>hong
>>
>>
>>kong words
>>http://www.microsoft.com/hk/hkscs/default.asp
>>you can see the details
>>The word I cannot insert is one out of 5000
>>sure I use N'...in asp page
>>And i use nvarchar for data type
>>it is unicode
>>that what I said it was running well before
>>but for special hong kong character
>>when insert, the words is crack
>>when update hong kong character, it is running well, no crack
>>
>>"Steve Kass" <skass@.drew.edu> wrote in message
>>news:uFMQzcP0DHA.604@.tk2msftngp13.phx.gbl...
>>
>>
>>
>>>Izumi,
>>>
>>>It is difficult to know, because you have not provided much
>>>
>>>
>>>
>>>
>>information.
>>
>>
>>>If you are inserting Simplified Chinese characters in GB encoding and
>>>Traditional (Hong Kong) characters in Big-5 encoding, perhaps you
>>>
>>>
>have
>
>>>code page support only for GB and not Big-5.
>>>
>>>If you can use Unicode in all cases, it should be possible to handle
>>>both character sets.
>>>
>>>Please tell us the data type of the column (probably varchar,
>>>
>>>
>>>
>>>
>>nvarchar,
>>
>>
>>>text, or ntext) how you are inserting data. INSERT query, or data
>>>
>>>
>file
>
>>>import, or typing in Enterprise Manager or some tool? Also, how do
>>>
>>>
>you
>
>>>do the update? If you specify character strings in a query, do you
>>>
>>>
>use
>
>>>N'ÄãµÄºº×Ö' or 'ÄãµÄºº×Ö' (is there N or not for Unicode)?
>>>
>>>It could also be a bug, and the additional information will help.
>>>
>>>SK
>>>
>>>izumi wrote:
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>I am using sql server 2000 english
>>>
>>>Once i insert chinese font, it is ok
>>>
>>>But when I insert one hong kong font, then it make whole chinese
>>>
>>>
>font
>
>>>crack...
>>>
>>>But when i copy whole message and update(not insert), then the text
>>>
>>>
>>>
>>>
>>can
>>
>>
>>>
>>>
>>be
>>
>>
>>
>>>shown
>>>
>>>is it microsoft bug?
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>
>|||I am pure Hong kong guy
anyway
thanks for your help
but i would like to wait microsoft's reply from your side......
if any update, can u send to hokalun@.netvigator.com
Thanks a lot
"Steve Kass" <skass@.drew.edu> ¦b¶l¥ó
news:urZwI8N1DHA.2480@.TK2MSFTNGP10.phx.gbl ¤¤¼¶¼g...
> izumi,
> If you speak Chinese, you might find some help by posting your
> question to the newsgroup microsoft.cn.iis.asp. There is also a
> Japanese inetserver.asp group and several English newsgroups under
> microsoft.public.dotnet.framework.aspnet.
> Steve
> izumi wrote:
> >Ok lets wait
> >I will call our users to use update function
> >that mean insert something rubbish, and then update that row of data.
> >
> >Thanks
> >"Steve Kass" <skass@.drew.edu> wrote in message
> >news:e9fvssR0DHA.832@.TK2MSFTNGP09.phx.gbl...
> >
> >
> >>Did you type 951 or 9511? I don't have any other good ideas, but I will
> >>mention this question to Microsoft and see what they say.
> >>
> >>SK
> >>
> >>izumi wrote:
> >>
> >>
> >>
> >>when i change to <%
> >>Session.CodePage=9511
> >>Response.Charset="big5"
> >>%>
> >>but it show error on asp
> >>rror Type:
> >>SessionID, ASP 0204 (0x80004005)
> >>An invalid CodePage value was specified.
> >>"izumi" <test@.test.com> wrote in message
> >>news:OtkahXQ0DHA.1700@.TK2MSFTNGP12.phx.gbl...
> >>
> >>
> >>
> >>
> >>good point
> >>i am using 950
> >>let me try 951
> >>
> >>sure both method is doing on Asp
> >>
> >>"Steve Kass" <skass@.drew.edu> wrote in message
> >>news:%23n5KoLQ0DHA.3116@.TK2MSFTNGP11.phx.gbl...
> >>
> >>
> >>
> >>
> >>Izumi,
> >>
> >>Do you update from the asp page also? If insert and update are both
> >>
> >>
> >>from asp page, but insert does not work, I'm not sure what the
problem
> >>
> >>
> >>
> >>
> >>is.
> >>
> >>
> >>
> >>
> >>What codepage does your asp page expect for input? Supplementary
Hong
> >>Kong character set is a new code page, 951.
> >>
> >>SK
> >>
> >>
> >>izumi wrote:
> >>
> >>
> >>
> >>
> >>
> >>Good, I find the good person to solve the problem
> >>u really understand my story
> >>
> >>ok
> >>let me explain
> >>ASP page to insert and update the character to sql server
> >>It is not GB
> >>It is Big5 actually
> >>but there are around 5000 Hong Kong words which is not Big5
> >>so we need some additional hong kong character set to recongize some
> >>
> >>
> >>
> >>
> >>hong
> >>
> >>
> >>
> >>
> >>kong words
> >>http://www.microsoft.com/hk/hkscs/default.asp
> >>you can see the details
> >>The word I cannot insert is one out of 5000
> >>sure I use N'...in asp page
> >>And i use nvarchar for data type
> >>it is unicode
> >>that what I said it was running well before
> >>but for special hong kong character
> >>when insert, the words is crack
> >>when update hong kong character, it is running well, no crack
> >>
> >>
> >>"Steve Kass" <skass@.drew.edu> wrote in message
> >>news:uFMQzcP0DHA.604@.tk2msftngp13.phx.gbl...
> >>
> >>
> >>
> >>
> >>
> >>
> >>>Izumi,
> >>>
> >>>It is difficult to know, because you have not provided much
> >>>
> >>>
> >>>
> >>>
> >>information.
> >>
> >>
> >>
> >>
> >>>If you are inserting Simplified Chinese characters in GB encoding
and
> >>>Traditional (Hong Kong) characters in Big-5 encoding, perhaps you
> >>>
> >>>
> >have
> >
> >
> >>>code page support only for GB and not Big-5.
> >>>
> >>>If you can use Unicode in all cases, it should be possible to
handle
> >>>both character sets.
> >>>
> >>>Please tell us the data type of the column (probably varchar,
> >>>
> >>>
> >>>
> >>>
> >>nvarchar,
> >>
> >>
> >>
> >>
> >>>text, or ntext) how you are inserting data. INSERT query, or data
> >>>
> >>>
> >file
> >
> >
> >>>import, or typing in Enterprise Manager or some tool? Also, how do
> >>>
> >>>
> >you
> >
> >
> >>>do the update? If you specify character strings in a query, do you
> >>>
> >>>
> >use
> >
> >
> >>>N'ÄãµÄºº×Ö' or 'ÄãµÄºº×Ö' (is there N or not for Unicode)?
> >>>
> >>>It could also be a bug, and the additional information will help.
> >>>
> >>>SK
> >>>
> >>>izumi wrote:
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>I am using sql server 2000 english
> >>>
> >>>Once i insert chinese font, it is ok
> >>>
> >>>But when I insert one hong kong font, then it make whole chinese
> >>>
> >>>
> >font
> >
> >
> >>>crack...
> >>>
> >>>But when i copy whole message and update(not insert), then the
text
> >>>
> >>>
> >>>
> >>>
> >>can
> >>
> >>
> >>
> >>
> >>>
> >>>
> >>be
> >>
> >>
> >>
> >>
> >>
> >>
> >>>shown
> >>>
> >>>is it microsoft bug?
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
> >
> >
>

High Availability and Scalability ...

We have a multi-lingual website (English, Spanish and German). We have a table called Posts that is potentially getting really big.

We are in the initial design phase of the database and would like to know what the experts are suggesting to keep our database mean and lean in the long run.

We have been talking about splitting the database up into 3 separate databases, one for English, one for Spanish and one for German. The language specific databases would also be hosted in countries where the language is spoken eg. the German database would be hosted in Germany.

Or maybe database partitioning by language?

Making changes to 3 databases once launched seems like a nightmare. It would be nice to have one main database and maybe 2 (Spanish and German) “satellite” databases or something like that – any ideas?.

Any suggestions of how to deal with this problem the best way would be greatly appreciated. We are using SQL Server 2005.

Newbie!

moving out of replication forum and into TSQL forum.

What is your business requirement exactly? It's not clear what you mean by "lean and mean", nor is it clear exactly what problem you think you're going to have. Disk space? Performance?

|||

i think you need to design an application that service these different languages.

there are two approach that you can use. one is to have a central database that holds all the data. the other is to partition this into different site and database.

for the first approach say you are to design an inventory database. for your product table you will a design such as these:

product_id

barcode

productname_english

productname_spanish

productname_german

quantity

the advantage of this design is that

1. you have a live count of your inventory without querying so many database.

2. you use less machine

3. administered by less people

the disavantage of this design is

1. its difficult to implement.

2. there is no site autonomy

3. if the system fails every site fails.

4. difficult to maintain

the second approach is to break the database into a per site basis. that is you have an english database, spanish database and german database. if this approach is taken i suggest also that there must be a separate system for each language.

the advantage of this approach

1. there is site autonomy

2. easy to implement

3. faster site query due to less data.

the downside

slow query for comprehensive and overall reports

need lot of people

need several machine and server.

after some consideretion i would suggest that the second approach be taken due to the following reason. machine and people are cheap if it is to be compared with the confusion between people and the importance of autonomy of each site.

furthermore after implementation of OLTPs on different site i suggest a datawarehouse that shall consolidate data from different sites

regards

|||

We are worried that our posts table (blog entires, forum entries and pictures, everything is a post in our system) is getting too big with all the posts from the different languages. We are thinking of ways that we could avoid our performance going down when a German speaking user is coming to our site and we only need to show content in German. If all the languages are together in the same table we worry that the queries would take a long time to find the language specific content.

So we are debating if we should have a separate database for each language or if we could somehow have one main database in the United States for example and 2 satellite databases in different countries. The satellite databases which would hold only the records for a specific language for example German in Germany would once a day synchronize their data with the main database.

I hope this makes it a little clearer what our dilemma is.