Datatype have changed from Text10 -> Code10, what is the equivalent type in mysql?

Question

I have a ssis package that reads data from a third party database, and then writes that data to my database. I have received an email from them that the following from their database is changing:

• Table 6014407 Audit Roll:

  • Field 11 - "Unit":

  • Name change: "Unit" -> "Unit of Measure Code"

    • Data type change: Text10 -> Code10

my current definition in sql when creating the table for Unit is NVARCHAR(10) for Text10, but I'd like to know what the equivalent datatype is for Code10, as I'm not familiar with that type

Answer 1

I think you are working with Microsoft Dynamics NAV since it supports TEXT and CODE data types.

Referring to Text Data Type in Dynamics NAV documentation:

This simple data type denotes a text string.
...
The Text data type supports Unicode.

In addition, from Code Data Type in Dynamics NAV documentation:

It denotes a special type of string that is converted to uppercase and removes any trailing or leading spaces.
...
The Code data type supports Unicode.

Based on that you can still use NVARCHAR(10) for this data type.