How to install cURL with openssl on ubuntu server?

Question

I'm looking to set up a Entity-Attribute-Value table model, where I want the table to handle various data. I'd like to use nvarchar(max), but I'm worried that it may affect database performance (even though most data will be under 50 chars).

Solution

Try to reinstall php5-curl from the official Ubuntu 10.04 repository.

The output of php5 -i (when php5-cli and php5-curl are installed) states it supports SSL:

cURL support => enabled
cURL Information => 7.19.7
Age => 3
Features
AsynchDNS => No
Debug => No
GSS-Negotiate => Yes
IDN => Yes
IPv6 => Yes
Largefile => Yes
NTLM => Yes
SPNEGO => No
SSL => Yes
SSPI => No
krb4 => No
libz => Yes
CharConv => No
Protocols => tftp, ftp, telnet, dict, ldap, ldaps, http, file, https, ftps
Host => x86_64-pc-linux-gnu
SSL Version => OpenSSL/0.9.8k
ZLib Version => 1.2.3.3

Since your output contains another version of libcurl you might want to check what distribution is actually running on your office server.

Comments

[marc_s]

See : What's the point of using VARCHAR(n) anymore? - yes, it does matter - and using all (n)varchar(max) is a really really bad design IMHO

[Kermit]

What other db's use nvarchar?

[Larry Lustig]

The comment to which you linked (for SQL Server) states that the NVARCHAR(X) and NVARCHAR(MAX) are treated identically as long as the stored text length fits within 8000 characters. Only values longer than 8000 characters will suffer any performance hit -- and if you have any of those values you need NVARCHAR(>8000) anyway.

[Larry Lustig]

Good point. (N)VARCHAR, as opposed to VARCHAR is primarily SQL Server (although it will be accepted and mapped to TEXT by SQLite).