Need Urgent Help with foreign characters 
Author Message
 Need Urgent Help with foreign characters
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



Fri, 04 Apr 2003 03:00:00 GMT
 Need Urgent Help with foreign characters

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



Fri, 04 Apr 2003 03:00:00 GMT
 Need Urgent Help with foreign characters

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


Quote:
> 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



Fri, 04 Apr 2003 03:00:00 GMT
 Need Urgent Help with foreign characters

Inline

Quote:
> 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!

Quote:

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



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



Fri, 04 Apr 2003 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Need Urgent Help with foreign characters

2. Need Urgent Help with foreign characters

3. Need Urgent Help with foreign characters

4. Need urgent help on foreign characters. Thank you

5. Urgent Help Needed: How to load french characters to a table using SQLLDR

6. Urgent Help Needed AP/SCO 6.1 - HELP!!

7. Newbies need help.........Urgent please help.....!!

8. HELP PLEASE: URGENT: Need help forming a multi table query

9. Urgent help needed please help

10. URGENT ASAP Help NEEDED HELP ANS_NULLS

11. Newbies need help......Urgent please help!!

12. Please Help Urgent help needed!!!!


 
Powered by phpBB® Forum Software