sql server 2005, password character set

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Security » sql server 2005, password character set

sql server 2005, password character set

Rate Topic

Display Mode

Topic Options

Author

Message

harriet.louis

Posted Friday, June 12, 2009 7:26 AM

SSC 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 »

Permissions