Character (binary)

[mkendi]

Within the project-manager I am able to add a binary-character field into a table.
But how I am able to do this with the SQL command CREATE TABLE? There is only the filed-type CHAR.
Thanks in advance

 

[stuartdunkeld]

You can use the NOCPTRANS clause in CREATE TABLE, something like
create table c:\temp\test (char c(20) nocptrans)

From the docs:
NOCPTRANS
Prevents translation to a different code page for character and memo fields. You can specify NOCPTRANS only for character and memo fields. This creates what appears to be Character (binary) and Memo (binary) data types in the Table Designer.

Regards

STuart DUnkeld

 

[mkendi]

Thank you!
But I have anyway a problem with my index. There is a field with binary information and an index for this field.
But SEEK returns TRUE, alltrough it is allways the first record. Once, after changing from CHAR to CHAR Binary within the Project-Mng. I solved this problem. But now, after creating it again with CREATE TABLE I have the same problem again (CodePage is also set correctly).