Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql server 2005, password character set Expand / Collapse
Author
Message
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: Monday, July 12, 2010 8:36 AM
Points: 26, Visits: 98
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....
Harriet
Post #733807
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse