Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

sql server 2005, password character set Expand / Collapse
Posted Friday, June 12, 2009 7:26 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 10, 2015 5:08 AM
Points: 29, Visits: 109
Hello All,

My Windows cmd line application cannot log in to my db, using a password that contains special character '¤'.

However if I log in using management studio, it works fine.

It also works fine if I use passwords without special characters.

The application is written in java, and is passed as a connection string; Strings in java, I know is UNICODE.

1. Does anyone know how to check what character set SQL Server is using?

2. I think there may be something wrong in the translation of the password between certain character sets, and I was wondering if anyone here knows how to solve the problem?

Thanks in advance....
Post #733807
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse