Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft SQL Server > Latin1_General_...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 11171 of 11517
Post > Topic >>

Latin1_General_BIN comparing two char strings

by igor <igorss@[EMAIL PROTECTED] > Jun 23, 2008 at 04:26 PM

My database is Latin1_General_BIN.
My table is called CUSTOMER.
One column in this table (descr_id) is defined as char(10).

When I query=85

SELECT *
FROM CUSTOMER
WHERE descr_id =3D =91ABCD=92

Result set from above query is:
descr_id
ABCD

I get the same result back as I do when=85
SELECT *
FROM CUSTOMER
WHERE descr_id =3D =91ABCD      =91 (notice ABCD string has padded
spaces).

Result set from above query is:
descr_id
ABCD

Does anyone know why this is the case? I would expect second query to
not to return anything.

Many thanks,
Igor
 




 4 Posts in Topic:
Latin1_General_BIN comparing two char strings
igor <igorss@[EMAIL PR  2008-06-23 16:26:06 
Re: Latin1_General_BIN comparing two char strings
"Plamen Ratchev"  2008-06-23 23:26:52 
Re: Latin1_General_BIN comparing two char strings
igor <igorss@[EMAIL PR  2008-06-23 21:20:22 
Re: Latin1_General_BIN comparing two char strings
"Plamen Ratchev"  2008-06-24 08:59:39 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Dec 3 1:16:47 CST 2008.