<font face='Arial'>When establishing a new database connection to my SQL Server 7 database with DreamweaverMX 2004, I receive bad catalog informations for all "NVARCHAR" fields. The catalog (database definiton) I received in Dreamweaver MX are all "NCHAR" data type for those fields.

This is very problematic because all data value are padded with space to the length of those fields. I absolutly need to use NVARCHAR in dreamweaver.

Origin of this situation:
--------------------------
I was using NCHAR previously in the database definition, but I've change this datatype after an import from Access.Mdb.

I suspect that the catalog was not correctly updated on those tables or may be the catalog is stored outside database?. When I look tables definitions with SQL Server, all fields correctly report to be NVARCHAR. Dreamweaver does not receive accurate information now. How can I fix it?

Thanks for your help!

Jim

</font id='Arial'>

I made a mistake: SQL Server 2000 is in use.

Just for clarification, this was a database built in Access and "upsized" to SQL Server 2000, correct?

Yes. An IMPORT DATA from Access (.MDB FILE) to SQL 2000.

I found the problem yesterday night. It was the DATASET DEFINITION pre-builded in aspx page by Macromedia Dreamweaver that was using the old data types. I've now corrected the problem. Thanks!