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 |