I would like to use the following query:
SELECT english || '\n' || english || '\x2028' || french AS output FROM vocab_words_translated;
where \x2028 is the hexadecimal code for a soft carriage return.
However, this does not work.
Can anyone help with this problem?
Thanking you,
John
Pertinent codes:
2028 LINE SEPARATOR * may be used to represent this semantic unambiguously
U+2028, character
, decimal 8232, hex 0x2028, octal \20050, binary 10000000101000UTF-8: 0xe2 0x80 0xa8