Jillian Koskie wrote:
>  
> Is there any way to search my database for the offending records?

Perhaps the following would work:
SELECT ID
FROM table
WHERE octet_length(field) <> octet_length(convert(field, 'UNICODE'))

But don't continue with a hodgepodge. Bite the bullet, convert
your system to unicode.

Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to