I am new to setting up a MySQL parts data base however I have managed to use MySql Community version to create a small database jus one table and 2 or 3 row. All i was trying to do is create a table and connect to the databse from Orcad CIS. It went fine i was able to do all of these but when I went to configure CIS I keep getting the ERROR #8023
ERROR #8023 The Table Propoerty Type of field Part Number in table main parts is not TEXT, STRING or CHARACTER
I have this property set as CHARACTER, i have also tried to set it to TEXT and then to Varablecharacter but every time i keep getting the ERROR #8023.
Can some one please help me.
We're doing this and did have problems earlier but don't remember the cause or fix but I think it had to do with one of the table names being a reserve MYSQL word. Try changing the field name to something else without a space (include an underscore or something). And, sounds like you already tried VARCHAR but if not then try changing type to VARCHAR(<number>) where<number> is a numerical number such as 40 or 80...
In reply to Khurana: