SEARCH WRONG CHARACTER IN VARCHAR AND CHANGE

gsoletgsolet
in General Discussion

Hi,
We have bad characters in field VARCHAR like :
56553 �
The first value is the value returned by the function ASCII for the bad character.
My question is, how I can use the function REPLACE or other to change this character by an other, the place of this character can be anywhere in the field.
Gilbert

Comments

  • Alex_MakrisAlex_Makris

    I am not sure I understand your example, nor why you are incorporating ASCII into your description of the problem.

    Perhaps share possible inputs and expected outputs.

  • gsoletgsolet

    The problem is simple.
    In the table, we have in a field load from a file and the accented letters have the format ASCII 56553 .
    So, How to load a UTF8 file into a Vertica database ?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...