Questions tagged as 'varchar'

3
answers

Difference between type text and varchar type in SQL Server

What's the difference between using type text instead of type varchar to store information in the database? Is there a performance problem? So I have a table in the database that has a text column and it several times timeout error...
asked by 17.12.2014 / 17:36
3
answers

Search for certain dates in the VARCHAR field in SQL (MySQL)

I have the following condition: WHERE sv_users.userDataNascimento LIKE '%95%'; And this condition searches on a date ( 11/12/1995 ), type VARCHAR and not Timestamp , a year ending with the numerals 95 . This numera...
asked by 16.01.2014 / 13:07
4
answers

String Concatenation in SQL

I make a query in a table in my MySQL database that returns the following fields: usuarioId nome sobrenome idade sexo escolaridade modeloNome hora Follow the sql below: SELECT sv...
asked by 15.01.2014 / 16:13
2
answers

Length of field occupies total value defined?

If the maximum length of a field of type VARCHAR is 65535 (ocupa 65KB) , will it always occupy a space of 65KB in the database for each line even if I put less text in it? EXAMPLE: Does a VARCHAR(65000) field occupy 65kb e...
asked by 26.05.2017 / 19:14
1
answer

It makes a difference to use LONGTEXT instead of VARCHAR (255)

I would like to know if I use LONGTEXT instead of VARCHAR (255) would cause more lag, which would have a greater advantage ??     
asked by 28.05.2015 / 17:08
2
answers

Length of field occupies total value defined?

If the maximum length of a field of type VARCHAR is 65535 (ocupa 65KB) , will it always occupy a space of 65KB in the database for each line even if I put less text in it? EXAMPLE: Does a VARCHAR(65000) field occupy 65kb e...
asked by 26.05.2017 / 19:14
2
answers

In terms of performance, "character varying" or "text" in PostgreSQL?

Before posting this question I searched the internet to know the differences and performance of each type and I came to the conclusion that I should discuss a little more about this subject here with the experts, rs, I already know the differenc...
asked by 28.11.2017 / 12:26
1
answer

Help with field to save a link

I need to save a link in the database, which in the case is MySQL, I was using VARCHAR (255), but I easily noticed some of the stored links exceeded 255 characters, what kind of data can I use in the database to store this information? I believe...
asked by 17.04.2017 / 02:50
1
answer

How to determine the type of data to use in this flexible case?

The project consists of a database for RPG tokens (D & D and similar). It looks like this:    Database   tab       Tables       character    system    raca    class    attribute    character_atribution    Relationships      ...
asked by 16.11.2018 / 23:23
0
answers

Convert Varchar column to Date without losing data

Before the database was saving the date in a varchar field and the Brazilian standard (% with%), then I modified the values using the code below: UPDATE tabela SET coluna= DATE_FORMAT(STR_TO_DATE(coluna, '%d/%m/%Y'), '%Y-%m-%d') WHERE coluna L...
asked by 23.09.2018 / 21:02