Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
maydo
Starting Member
20 Posts |
 Posted - 2005-08-23 : 10:49:22
|
| Hello, is there any way to detect if a nvarchar field in a table contents at least one character with unicode greater than 127.thanks |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-08-23 : 11:32:40
|
| Well, it's not pretty but there is a unicode function in sql server that will return the unicode value of a character. If you created a function to parse a string and fed that into the unicode function, you could test for it. However, if you're running a lot of data through this it's not going to perform very well for you.Mike"oh, that monkey is going to pay" |
 |
|
|
maydo
Starting Member
20 Posts |
Posted - 2005-08-23 : 11:50:22
|
quote:
Originally posted by mfemenel
Well, it's not pretty but there is a unicode function in sql server that will return the unicode value of a character. If you created a function to parse a string and fed that into the unicode function, you could test for it. However, if you're running a lot of data through this it's not going to perform very well for you.Mike"oh, that monkey is going to pay"
well this was my first thought but it doesn't seem to be very effective |
|
|
|
|
|
|
regular expression