insert in dB string whit 8bit caracter

[Roberto Zanaboni]

Dear Forum

via serial port i receive number from 0 to 255. Using C# i can convert
in string using the extended encoding,so all in not cutted to 7 bit .
Of course the string now show very unreadeble caracter.

I want memory this string, long 500 char, in a rows of varchar(500).

Operation is good only ..seems..if the string contain 7 bit caracter ,but give error if contain extended character.

Problem is sure because insert need "" as delimeter of value ,and this can be false generated from some char in the string of ascii value= ".

What can i do ?

1 idea is to translate all string in exadecimal value, so i have only 7 bit char

Es HELLO ---> 48h 45h 4Ch 4Ch 4Fh

Some idea better ?

Many thanks
Roberto