flynny
asked on
varchar(0) Length or precision specification 0 is invalid. MSSQL
Hi all,
I am trying to export a database structure from MYSQL and import to MSSQL.
Now I am getting the above error on creating tables with varchar(0).
what should i replace this with? (i assume a BIT?)/
I am trying to export a database structure from MYSQL and import to MSSQL.
Now I am getting the above error on creating tables with varchar(0).
what should i replace this with? (i assume a BIT?)/
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Kent,
thanks for that I assumed it was zero based, hence a bit
thanks for that I assumed it was zero based, hence a bit
Curiosity overwhelms me ... what would be an example of a character value with zero characters in it?
You're going to need a number that is the maximum amount of characters you forsee going into that value.
For example: First names -15, last names-25, US Zip codes-10.
Tell us the values that will go into this column, and we'll recommend an appropriate data type.