Questions tagged [varchar]
A varchar or variable character field is a set of character data of indeterminate length.
varchar
1,456
questions
1
vote
1
answer
80
views
Fetching unexpected results from WHRE clause with bpchar and character varying fields
I am new to PostgreSQL.
In my Postgres 14.8 database I have a students table. When executing the query:
SELECT stud_id, batch_type, subject, jdate ,subj_id, sdtime, subj_hours
FROM studs
ORDER BY ...
- 11
-1
votes
0
answers
54
views
OCSInventory Agent inserts an array in MySQL database instead of the string it should do
I have my agent working on my client machine which gathers listening ports and put them to a string this way :
my $portsTemp = `lsof -P -p $pid | grep LISTEN | grep -v localhost | cut -d&...
- 122
0
votes
0
answers
35
views
XML path into temp table creates a nvarchar column, issues when merging it varchar column
I using SQL Server 2012 and need to use FOR XML PATH to get a comma-separated string for like projects. The query runs and works but when I try to alter #T2, I get an error
String or binary data ...
- 31
1
vote
1
answer
35
views
Conversion failed when converting the varchar value '1.1' to data type int
I have two columns, one of data type Smallint and the other int. I am trying to concatenate the two columns and a '.' to produce one final value but I keep getting the error:
Conversion failed when ...
- 139
1
vote
1
answer
68
views
Access token from Azure App has 6k+ chars & unable to save encrypted in SQL Server due to length restriction [closed]
To authenticate mail server from an application we use OAuth authentication. Application uses Java mail API for SMTP mail communication. We create an app in Azure and use its client ID and client ...
- 11
0
votes
1
answer
60
views
How does postgres stores varchar attribute value in heap table as tuple
I having been going through how postgres actually stores data in heap table tuple
I initially created table, and populated sample values.
Later tried to print the attributes stored
test=# SELECT * ...
- 11
0
votes
1
answer
100
views
Redshift STL_LOAD_ERRORS col_length (256) different than DDL (12000)
I have a table called 'sales' which has a column called 'reason'. I am trying to load data into the column.
The data is;
"They found an issue with the software causing one of the chips an
issue ...
- 41
0
votes
1
answer
42
views
Uncontrollable MySQL ibd datafile resizing
My mySQL database has quite a number of columns (aprox. 750). Besides mostly DECIMAL(13,2) also some short CHARs, INTs and aprox. 25 columns of CHAR(150). The number of all rows is approximately 27,...
-1
votes
1
answer
191
views
TYPE CONVERSION: How do you convert a string to a decimal?
I'm trying to sum a column of varchar data, however the values all have commas and decimal points in them. It appears that the query cannot convert a string to a decimal. Help!
I have tried the below ...
- 1
0
votes
1
answer
38
views
Citibike data date format
I am using Citibike data and load it to snowflake table but as data is loaded I was having issues in loading online data I loaded it into a varchar data type. So its from CSV file and date is loaded ...
- 1
0
votes
0
answers
38
views
SSIS data conversion loses extended ASCII
I'm reading from a data source that returns unicode strings, and the output goes into a data conversion transform where I output a "string [DT_STR]" from it as my database is using varchar ...
- 10k
0
votes
1
answer
339
views
Issue saving Latin characters on SQL Server
I'm having an issue when saving text data to a SQL Server 2019 database using Latin_General_CI_AS as the default collation. The column in question is set as varchar. When the client types a word like ...
- 57
0
votes
2
answers
385
views
How to alter column to VARCHAR type with length L where L is based on the column aggregation like MAX(LENGTH(column)), PostgreSQL DB?
I am trying to alter column named names type from text to VARCHAR with length L. Where L is the maximum length of the names. I am trying with inner/sub-query as follows:
Is this even possible? Any ...
- 21
0
votes
2
answers
139
views
How can I insert long string into UTF8-collated varchar(N) column?
I have data in VARCHAR(MAX) source, that I need to insert into another table as VARCHAR(N).
The collation I need to use is UTF8 (specifically Czech_100_CI_AS_SC_UTF8).
The problem is, even if I cut ...
- 23
0
votes
0
answers
223
views
run-time error '-2147217913 (80040e07)' in Excel VBScript app affects different users differently
This triggers when the VBScript (in an excel based app) attempts to complete a userform and insert data into a table in a SQL database.
This affects only one user, it works fine for everyone else.
The ...
- 48