Is there any way to store character in MS access without being changed?

I am trying to store encrypted data in ms access but characters afters 128 change

eg. 'Ö¤crÉòaqÆrõ~C' is sent to access which is received as 'Ö¤crÉòaqÆrõ~C' missing or converted symbols.

is there any way to retrieve text without being changed.

[Walter Roberson]

Your posting contains unprintable characters. Using HTML entity notation, your source string is

Ö¤crÉòaqƒÆrõ~’C

and the received string is

Ö¤crÉòaqÆrõ~C

Answer 1

[Walter Roberson]

This appears to be a limitation in using unicode text in some versions of MS Access. See for example https://social.msdn.microsoft.com/Forums/en-US/5e129981-58af-4891-979f-cf31e3fdaaca/inserting-unicode-characters-into-an-ms-access-database?forum=adodotnetdataproviders

The characters that are failing are getting turned into char(26), which is the character that is returned if a source character cannot be translated into the target character set; see for more discussion

You could try a native2unicode() with UTF-8 specified, and unicode2native() on the way back. This would give you variable length byte arrays to be stored, by the way.

But really, you should just switch to storing byte arrays.

[Aspire]

i tried 'UTF-8', 'latin1', 'US-ASCII', and 'Shift_JIS', '' and window-1521 with native2unicode(). answer is same char(26).

and storing byte arrays means uint64?

[Walter Roberson]

byte arrays are uint8

[Aspire]

State is in Hex

State =  {'F7'    'B5'    'FA'    'C0';
          '88'    '46'    '51'    'C3';
          '38'    'F7'    'CD'    '7B';
          '92'    'D9'    '2D'    '9C'}

          X=[];
          [m,n]=size(State);
           for i=1:m
               for j=1:n
                   X(i,j)= hex2dec(State(i,j));
               end
           end
           X;
           X=char(X);
           reshapeX = reshape(X,1,16)
           size(reshapeX);

can u please help.

I used uint8 after Char(X) and got same result without uint8 '÷8µF÷ÙúQÍ-ÀÃ{' but after retriving from access char(26) appears i.e '÷8µF÷ÙúQÍ-ÀÃ{'

[Walter Roberson]

Why are you not using an array of Byte?

https://www.w3schools.com/sql/sql_datatypes.asp