Need Urgent Help with foreign characters

[Sandra Clifford]

Hi,

I am in the U.S. I have my computer and MS SQL 7.0 configured for English
alphabet. How do I type foreign letters directly into tables? There are
letters in foreign languages that look different than English. Is there an
easy way of typing them in the MS SQL 7.0
Can you give me a step by step example on what I need to do to type foreign
characters into my tables.

Please help.
Thank you very much.

Sandra

[Sandra Clifford]

[David Lundell]

Here is an example using a temporay table called #testing:
insert #testing (someText) Values (NCHAR(257))

NCHAR accepts a numeric and then returns the character for that value.

Or you can type them directly in query anlyzer by holding down ALT and then
typing a number using the keypad (not the number line above -- only the
keypad will work)

David Lundell
MCDBA, MCT, MCSD, MCSE+I, CCNA, CNA

"Sandra Clifford" <sandrac...@yahoo.com> wrote in message
news:2IzG5.12119$f5.4...@news1.sttls1.wa.home.com...

[David Lundell]

Inline
"David Lundell" <dlun...@dratraining.com> wrote in message
news:#89DAV3N...@cppssbbsa02.microsoft.com...

> Here is an example using a temporay table called #testing:
> insert #testing (someText) Values (NCHAR(257))
>
> NCHAR accepts a numeric and then returns the character for that value.
>
> Or you can type them directly in query anlyzer by holding down ALT and
then
> typing a number using the keypad (not the number line above -- only the
> keypad will work)

THIS last part does not work -- my mistake it only does the extended ascii
set so anything above 255 is calculated as modulo 256 and then the
corresponding ASCII value is entered. Nonetheless the NCHAR does work!