Strategies for preserving line breaks in a database

Question

Strategies for preserving line breaks in a database

I am currently utilizing TypeORM for managing my database with NestJS framework on the server side and Vue.js on the client side.

Within the settings, I need to input a large text and ensure that line breaks (\n) are saved in the database.

Here's a snippet of my code:

Vue textarea

<b-form-textarea 
       style="white-space: pre-line"
       v-model="projectShortDesc"
       class="mt-2 description-input"></b-form-textarea>

Afterward, I send this data from

v-model="projectShortDesc"

to my server.

@Column({
    type: 'varchar',
    length: 150,
    nullable: true
})
shortDescription: string;

To save it, I use the following method:

project.shortDescription = descFromVue;
await this.conn.getRepository(Project).save(project);

Could someone please advise me on how to store '\n' in the database when pressing enter in the description field?

Many thanks for any assistance provided!

javascript typescript vue.js nestjs typeorm

Answer 1

Answer №1

If you want to insert line breaks in a MySQL database, remember to add /n whenever the user presses the enter key in the text box. This simple trick can make it easier for you.

<template>
  <div id="app">
     <b-form-textarea 
       style="white-space: pre-line"
       v-model="projectShortDesc"
       class="mt-2 description-input"
        v-on:keyup.enter="onEnter">
      </b-form-textarea>
  </div>
</template>

<script>
export default {
 name: "App",
 methods: {
  onEnter() {
    this.projectShortDesc.apend('/n')
    },
 },
};
</script>

Answer 2

If you want to insert line breaks in a MySQL database, remember to add /n whenever the user presses the enter key in the text box. This simple trick can make it easier for you.

<template>
  <div id="app">
     <b-form-textarea 
       style="white-space: pre-line"
       v-model="projectShortDesc"
       class="mt-2 description-input"
        v-on:keyup.enter="onEnter">
      </b-form-textarea>
  </div>
</template>

<script>
export default {
 name: "App",
 methods: {
  onEnter() {
    this.projectShortDesc.apend('/n')
    },
 },
};
</script>

Strategies for preserving line breaks in a database

Answer №1

Similar questions

What is the procedure for modifying the height of a button in HTML?

Problems Arising from the Combination of Django and External JavaScript

Encountering an issue with react-dom that needs to be resolved

Tips for choosing a codemirror instance in vue

Set up ExpressJS to utilize port 3000 for the server

Approximating Values with JavaScript in Selenium

Problem with integrating MEAN stack and bootstrap using bower

experiencing deployment issues with the openai npm package

Having issues with the functionality of jQuery. It needs to be able to override existing

What steps are necessary to create an npm package utilizing three.js without any dependencies?

Issue with stacking layers

Tips for transferring a JSON object from an HTML document to a JavaScript file

When using TypeScript and Material UI, it is important to assign a value to boolean attributes

The if statement remains active without being disabled

Tactile interactions on iPhone

Facing a Challenge with Textures in ThreeJS ShaderMaterial

Is there a way to utilize javascript std input/output in repl.it effectively?

Tips for securely concealing login details during an API call

A method for dividing a string into separate characters and organizing them into an array of JSON objects

The left margin of the Bootstrap 12 column grid is not aligned correctly