Inserting text containing Bullet point as part of the text in VARCHAR2 column in Oracle

General Discussion
1

Hi,
We are trying to insert multiline text into a VARCHAR2 col in Oracle and the value contains Bullet Point as part of the text for some records. The text gets inserted successfully but it does not preserve the original bullet point format in the database. Please note that the text gets inserted with the original format when we do this out of Liquibase. Can you please suggest how to preserve the original bullet point in the text while inserting into a VARCHAR2 column in Oracle by Liquibase. Thanks in advance.

Example: 'This is an example of multiline text

  • That contains bullet point as part of the text’

Regards;
Gopal

2

Please provide your changeset as an example.

3

Change set is like as mentioned below:


data.sql

image

4

Below is the changeset:-

image
image710×201 5.88 KB

5

We need to see the sql statements.

6

image
image795×163 3.79 KB

7

please find mentioned above the SQL.