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?
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
> >
> >
>