Hi friends !, maybe you can help me...

I'm developing an application in VB6 that connects to a SQL Server 2000 database.
In table NOTES I have a field called NOTE of type ntext with collation Hebrew_CI_AS, because I need to store notes in hebrew language. However, the default database language is Spanish.

The problem is: when I retrieve from the application the field NOTE, "??????" characters appear, instead of the proper hebrew characters. Are the characters correctly stored, or is it another kind of problem ? Do I have to do anything else to store hebrew characters, apart from setting the collation?

Thanks !!!!