Questions tagged as 'varchar'

Is there any problem in changing the data type from varchar to int in mysql? I have a spreadsheet with some items that have been entered as varchar, all are numbers. The problem is that I need to do a bigger and smaller search, however, as it is...

I'm working on an EAD project where I work. They will be simulated with many questions and their answers. These questions and some answers are usually quite large and I'm storing them as VARCHAR (MAX) on a SQL Server database. The question...

How can I convert dates to varchar for date ? I'm having difficulty performing cross-date searches because of this discrepancy in the database where I query. When I enter my line of code: select * from TAB_FATURAMENTO where cd_cliente li...

I have a .csv file that contains columns (vertically): Product.1 (line1) Product.2 (line2) But when I do this query : use test; LOAD DATA LOCAL INFILE 'local' INTO TABLE tabela1; It always gives me a warning to say that the att...