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 10000000101000 UTF-8: 0xe2 0x80 0xa8
