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

1 次查看（过去 30 天）
Aspire
Aspire 2017-5-7
评论： Walter Roberson 2017-5-10
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.
  1 个评论
Walter Roberson
Walter Roberson 2017-5-7
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

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Walter Roberson
Walter Roberson 2017-5-7
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.
  4 个评论
显示 2更早的评论
Aspire
Aspire 2017-5-10
编辑：Walter Roberson 2017-5-10
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Í-ÀÃ{'

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Characters and Strings 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by