"special characters not allowed"

"special characters not allowed"

Post by d.--->rapto » Fri, 17 May 2002 00:17:12



hi everybody,
i can't find the list of "special characters" that sql2000 is not able to
manage (i.e. -->  '+',  '-', ...)

do you know where i can check to find it?
thanks,
d.

 
 
 

"special characters not allowed"

Post by Hilary Cotte » Fri, 17 May 2002 09:22:48


basically it is any non alpha-numeric character.


Quote:> hi everybody,
> i can't find the list of "special characters" that sql2000 is not able to
> manage (i.e. -->  '+',  '-', ...)

> do you know where i can check to find it?
> thanks,
> d.


 
 
 

"special characters not allowed"

Post by d.--->rapto » Fri, 17 May 2002 15:39:59


"Hilary Cotter" wrote

Quote:> basically it is any non alpha-numeric character.

i suspected this thing, but i hoped not so many characters (non
alpha-numeric items are a lot, and i got to teach my users not to use them).

thank yuo very much,
d.

 
 
 

"special characters not allowed"

Post by Hilary Cotte » Sat, 18 May 2002 09:36:58


filter the non-alphanumeric characters out at the client.


Quote:

> "Hilary Cotter" wrote

> > basically it is any non alpha-numeric character.

> i suspected this thing, but i hoped not so many characters (non
> alpha-numeric items are a lot, and i got to teach my users not to use
them).

> thank yuo very much,
> d.

 
 
 

1. Sort order with "special characters"

I haveing some problems with the sortorder when i get data from my SQL
2k database. I have som fields with ??? and the problem is that ? is
sorted as O and so on.

I dont realy know what settings this is controled by so any help would
be nice.

The regional settings on my computer is set to Swedish.
The "Server Coallition" is set to "SQL_Latin1_General_CP1_CI_AS"

Any more settings i should set?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

2. Got a Job, thanks: ColdFusion is it a reality ??

3. XSL Operators with Special Characters like "$"

4. University of Washington Oracle PL/SQL Class

5. "escape" special characters

6. reading .XLS files

7. Special "&" Character

8. Error "Full dBase expressions not allowed"

9. Database table "triangle"... allowed or not

10. "Server cursor not allowed..."?

11. "Operation is not allowed"

12. Special characters not allowed in string